home *** CD-ROM | disk | FTP | other *** search
/ U.S. Robotics Connections 2 / US Robotics Connections.iso / pc / sourcepc / uconnect / data.3 / program / appdb.ini next >
Encoding:
INI File  |  1995-10-20  |  9.4 KB  |  452 lines
  1. ///////////////////////////////////////////////////////////////////////////////
  2. // GENERAL INFORMATION
  3. ///////////////////////////////////////////////////////////////////////////////
  4. [Main]
  5. StaticConnection=
  6. DynamicConnection=
  7.  
  8. ///////////////////////////////////////////////////////////////////////////////
  9. // STATIC TABLE DEFINITIONS
  10. ///////////////////////////////////////////////////////////////////////////////
  11. [TAAIRLIN]
  12. Index=
  13. Column1=RECTYPE,TEXT
  14. Column2=VENDORCD,TEXT
  15. Column3=NAME,TEXT
  16. Column4=MPICD,TEXT
  17. Column5=SHORTNAME,TEXT
  18. Column6=PARTICIPNT,TEXT
  19.  
  20. [T4HOTEL]
  21. Index=
  22. Column1=RECTYPE,TEXT
  23. Column2=VENDORCD,TEXT
  24. Column3=NAME,TEXT
  25. Column4=MPICD,TEXT
  26. Column5=SHORTNAME,TEXT
  27.  
  28. [T5CAR]
  29. Index=
  30. Column1=RECTYPE,TEXT
  31. Column2=VENDORCD,TEXT
  32. Column3=NAME,TEXT
  33. Column4=MPICD,TEXT
  34. Column5=SHORTNAME,TEXT
  35.  
  36. [T6CURNCY]
  37. Index=
  38. Column1=RECTYPE,TEXT
  39. Column2=CURRENCY,TEXT
  40. Column3=NAME,TEXT
  41.  
  42. [TCLOOKUP]
  43. Index=
  44. Column1=RECTYPE,TEXT
  45. Column2=CATEGORY,TEXT
  46. Column3=APOLLOCD,TEXT
  47. Column4=DESC,TEXT
  48. Column5=SHORTDESC,TEXT
  49.  
  50. [TBOTHER]
  51. Index=
  52. Column1=RECTYPE,TEXT
  53. Column2=CATEGORY,TEXT
  54. Column3=APOLLOCD,TEXT
  55. Column4=DESC,TEXT
  56. Column5=SEQNBR,TEXT
  57. Column6=FLAGS,long
  58.  
  59. [TVENDORT]
  60. Index=
  61. Column1=DESC,TEXT
  62. Column2=VENDORTYPE,TEXT
  63.  
  64. [T8STATE]
  65. Index=
  66. Column1=RECTYPE,TEXT
  67. Column2=STATECD,TEXT
  68. Column3=COUNTRYCD,TEXT
  69. Column4=NAME,TEXT
  70.  
  71. [T9METRO]
  72. Index=
  73. Column1=RECTYPE,TEXT
  74. Column2=METROCD,TEXT
  75. Column3=ASSOCARPTS,TEXT
  76. Column4=NAME,TEXT
  77. Column5=INTLCODE,TEXT
  78.  
  79. [T1CITY]
  80. Index=
  81. Column1=RECTYPE,TEXT  
  82. Column2=CITYCD,TEXT  
  83. Column3=NAME,TEXT  
  84. Column4=COUNTRYCD,TEXT  
  85. Column5=STATECD,TEXT  
  86. Column6=METROCD,TEXT  
  87. Column7=LATSIGN,TEXT
  88. Column8=LATITUDE,long
  89. Column9=LONGSIGN,TEXT
  90. Column10=LONGITUDE,long
  91. Column11=ASSOCARPTS,TEXT
  92. Column12=HOSTSVC,TEXT
  93. Column13=SYNONYM,TEXT
  94. Column14=COMMERCIAL,TEXT
  95.  
  96. [T2ARPT]
  97. Index=
  98. Column1=RECTYPE,TEXT  
  99. Column2=ARPTCD,TEXT  
  100. Column3=NAME,TEXT  
  101. Column4=COUNTRYCD,TEXT  
  102. Column5=STATECD,TEXT  
  103. Column6=METROCD,TEXT  
  104. Column7=METACD1,TEXT  
  105. Column8=METACD2,TEXT  
  106. Column9=METACD3,TEXT  
  107. Column10=LATSIGN,TEXT
  108. Column11=LATITUDE,long
  109. Column12=LONGSIGN,TEXT
  110. Column13=LONGITUDE,long
  111. Column14=REFCITY,TEXT
  112. Column15=PHONEPREFX,TEXT
  113. Column16=ARPTTYPE,TEXT
  114. Column17=HOSTSVC,TEXT
  115. Column18=SYNONYM,TEXT
  116. Column19=FAREQUOTE,TEXT
  117. Column20=INTLARPT,TEXT  
  118.  
  119. [TTITLE]
  120. Index=
  121. Column1=APOLLOCD,TEXT
  122. Column2=DESC,TEXT
  123.  
  124. [TMODEMS]
  125. Index=
  126. Column1=VENDOR,TEXT
  127. Column2=MODEM,TEXT
  128. Column3=INITIALIZE,TEXT
  129. Column4=RESTORE,TEXT
  130. Column5=RESET,TEXT
  131.  
  132. [TVAN]
  133. Index=
  134. Column1=STATE,TEXT
  135. Column2=CITY,TEXT
  136. Column3=AREACODE,TEXT
  137. Column4=PHONENUMBR,TEXT
  138. Column5=BAUD,TEXT
  139.  
  140. ///////////////////////////////////////////////////////////////////////////////
  141. // DYNAMIC TABLE DEFINITIONS
  142. ///////////////////////////////////////////////////////////////////////////////
  143. [TTRAVELE]
  144. Index=ID
  145. Column1=ID,long
  146. Column2=LAST,TEXT
  147. Column3=FIRST,TEXT
  148. Column4=MIDDLE,TEXT
  149. Column5=TITLE,TEXT
  150. Column6=HOMEPHONE,TEXT
  151. Column7=BUSPHONE,TEXT
  152. Column8=PIC,TEXT
  153. Column9=GENDER,TEXT
  154. Column10=BIRTHDATE,TEXT
  155. Column11=MILEPLUSID,TEXT
  156. Column12=PREFAGENCY,TEXT
  157. Column13=ORIGIN,TEXT
  158.  
  159. [TCREDITC]
  160. Index=ID
  161. Column1=ID,long
  162. Column2=TR_ID,long
  163. Column3=ADDR_ID,long
  164. Column4=VENDORCD,TEXT
  165. Column5=ACCTNBR,TEXT
  166. Column6=EXPIREDT,DATETIME
  167. Column7=SERIESNBR,TEXT
  168. Column8=ALIAS,TEXT
  169.  
  170. [TADDRESS]
  171. Index=ID
  172. Column1=ID,long
  173. Column2=COMPANY,TEXT
  174. Column3=LOCATOR1,TEXT
  175. Column4=LOCATOR2,TEXT
  176. Column5=CITY,TEXT
  177. Column6=STATE,TEXT
  178. Column7=ZIP,TEXT
  179. Column8=COUNTRY,TEXT
  180.  
  181. [TAWARDPG]
  182. Index=TR_ID
  183. Column1=TR_ID,long
  184. Column2=ID,long
  185. Column3=NAME,TEXT
  186. Column4=VENDORTYPE,TEXT
  187. Column5=VENDORCD,TEXT
  188. Column6=MEMBERID,TEXT
  189.  
  190. [TDSCTCLB]
  191. Index=TR_ID
  192. Column1=TR_ID,long
  193. Column2=ID,long
  194. Column3=NAME,TEXT
  195. Column4=VENDORTYPE,TEXT
  196. Column5=VENDORCD,TEXT
  197. Column6=MEMBERID,TEXT
  198.  
  199. [TPROFILE]
  200. Index=TR_ID
  201. Column1=TR_ID,long
  202. Column2=ID,long
  203. Column3=PROFILENM,TEXT
  204.  
  205. [TFLTPREF]
  206. Index=PR_ID
  207. Column1=PR_ID,long         
  208. Column2=ADVPRCHDYS,int     
  209. Column3=MAXSTAYDYS,int     
  210. Column4=MINSTAYDYS,int     
  211. Column5=SEATLOCATN,TEXT    
  212. Column6=SVCCLASS,TEXT      
  213. Column7=SPCLMEAL,TEXT      
  214. Column8=SPCLSVC,TEXT       
  215.  
  216. [TFLTVEND]
  217. Index=PR_ID
  218. Column1=PR_ID,long
  219. Column2=VENDORCD,TEXT
  220.  
  221. [TCARPREF]
  222. Index=PR_ID
  223. Column1=PR_ID,long     
  224. Column2=LORATE,double    
  225. Column3=HIRATE,double    
  226. Column4=UNLMTDMILE,int 
  227. Column5=ARPTLOCATN,int
  228. Column6=SKIEQUIP,int     
  229. Column7=INFANTSEAT,int 
  230. Column8=TODDLRSEAT,int 
  231. Column9=RIGHTHANDC,int 
  232. Column10=LEFTHANDC,int
  233. Column11=MOBILPHONE,int   
  234. Column12=AWARDPG_ID,int
  235. Column13=USE_RATE_R,int
  236.  
  237. [TCARVEND]
  238. Index=PR_ID
  239. Column1=PR_ID,long    
  240. Column2=VENDORCD,TEXT 
  241.  
  242. [TCARTYPE]
  243. Index=PR_ID
  244. Column1=PR_ID,long    
  245. Column2=CARTYPE,TEXT  
  246.  
  247. [THTLAMNT]
  248. Index=PR_ID
  249. Column1=PR_ID,long     
  250. Column2=AMENITYCD,TEXT 
  251.  
  252. [THTLPREF]
  253. Index=PR_ID
  254. Column1=PR_ID,long
  255. Column2=RATECD,TEXT
  256. Column3=LORATE,double
  257. Column4=HIRATE,double
  258. Column5=MULTILEVEL,TEXT
  259. Column6=MOSTIMPORT,TEXT
  260. Column7=OCCUPANCY,int
  261. Column8=ADDLADULTS,int
  262. Column9=ADDLCHLDRN,int
  263. Column10=GUARANTEE,int
  264. Column11=ADDLBEDS,int
  265. Column12=CRIBS,int
  266. Column13=AWARDPG_ID,int
  267. Column14=USE_RATE_R,int
  268.  
  269. [THTLVEND]
  270. Index=PR_ID
  271. Column1=PR_ID,long   
  272. Column2=VENDORCD,TEXT
  273.  
  274. [TREGUSER]
  275. Index=ID
  276. Column1=ID,long
  277. Column2=LAST,TEXT
  278. Column3=FIRST,TEXT
  279. Column4=MIDDLE,TEXT
  280. Column5=TITLE,TEXT
  281. Column6=HOMEPHONE,TEXT
  282. Column7=BUSPHONE,TEXT
  283. Column8=MILEPLUSID,TEXT
  284. Column9=HOMEBUS,TEXT
  285. Column10=COMPANYNM,TEXT
  286. Column11=PASSWORD,TEXT
  287. Column12=SUBSCRIPTN,TEXT
  288. Column13=MEDIATYPE,TEXT
  289. Column14=REGISTERED,int
  290. Column15=WASPREVREG,int
  291.  
  292. [TCALLFRM]
  293. Index=DESC
  294. Column1=DESC,TEXT
  295. Column2=AREACODE,TEXT
  296. Column3=DIALTONE,TEXT
  297. Column4=LONGDIST,TEXT
  298. Column5=SUFFIX,TEXT
  299. Column6=CARD,TEXT
  300. Column7=CARDNUMBER,TEXT
  301. Column8=PAREACODE,TEXT
  302. Column9=PNUMBER,TEXT
  303. Column10=SAREACODE,TEXT
  304. Column11=SNUMBER,TEXT
  305.  
  306. [TWORKSTN]
  307. Index=
  308. Column1=ID,long
  309. Column2=SFWRVER,TEXT
  310. Column3=MKTGVER,TEXT
  311. Column4=REMPSWD,int
  312. Column5=UPGDSTATUS,int
  313. Column6=SFWRNEWVER,TEXT
  314. Column7=PLATFORM,TEXT
  315.  
  316. ///////////////////////////////////////////////////////////////////////////////
  317. // QUERY DEFINITIONS
  318. ///////////////////////////////////////////////////////////////////////////////
  319. [qryMAX_TTRAVELE_ID]
  320. Name=TTRAVELE
  321. SQL=SELECT MAX(ID) FROM TTRAVELE
  322. Column1=MAX,long
  323.  
  324. [qryMAX_TADDRESS_ID]
  325. Name=TADDRESS
  326. SQL=SELECT MAX(ID) FROM TADDRESS
  327. Column1=MAX,long
  328.  
  329. [qryMAX_TPROFILE_ID]
  330. Name=TPROFILE
  331. SQL=SELECT MAX(ID) FROM TPROFILE
  332. Column1=MAX,long
  333.  
  334. [qryMAX_TAWARDPG_ID]
  335. Name=TAWARDPG
  336. SQL=SELECT MAX(ID) FROM TAWARDPG
  337. Column1=MAX,long
  338.  
  339. [qryMAX_TDSCTCLB_ID]
  340. Name=TDSCTCLB
  341. SQL=SELECT MAX(ID) FROM TDSCTCLB
  342. Column1=MAX,long
  343.  
  344. [qryMAX_TCREDITCD_ID]
  345. Name=TCREDITC
  346. SQL=SELECT MAX(ID) FROM TCREDITC
  347. Column1=MAX,long
  348.  
  349. [qryFFNUMBER]
  350. Name=TAWARDPG
  351. SQL=SELECT ID, NAME, MEMBERID FROM TAWARDPG WHERE VENDORTYPE='A'
  352. Column1=ID,long
  353. Column2=NAME,TEXT
  354. Column3=MEMBERID,TEXT
  355.  
  356. [qryAMENITIES]
  357. Name=TBOTHER
  358. SQL=SELECT APOLLOCD, DESC FROM TBOTHER WHERE CATEGORY='HFA' ORDER BY SEQNBR
  359. Column1=APOLLOCD,TEXT
  360. Column2=DESC,TEXT
  361.  
  362. [qryAIR_VENDORNAME]
  363. Name=TAAIRLIN
  364. SQL=SELECT SHORTNAME FROM TAAIRLIN WHERE PARTICIPNT='Y'
  365. Column1=NAME,TEXT
  366.  
  367. [qryAIR_LOCATIONNAME]
  368. Name=T2ARPT
  369. SQL=SELECT NAME FROM T2ARPT
  370. Column1=NAME,TEXT
  371.  
  372. [qryGET_AIRPORT_LIST]
  373. Name=T2ARPT,T1CITY
  374. Join=T2ARPT.REFCITY,T1CITY.CITYCD
  375. SQL=SELECT T2ARPT.NAME, T1CITY.NAME, T2ARPT.STATECD, T2ARPT.COUNTRYCD FROM T2ARPT LEFT JOIN T1CITY ON T2ARPT.REFCITY = T1CITY.CITYCD
  376. Column1=ARPTNAME,TEXT
  377. Column2=CITYNAME,TEXT
  378. Column3=STATECD,TEXT
  379. Column4=COUNTRYCD,TEXT
  380.  
  381. [qryGET_METRO_LIST]
  382. Name=T9METRO,T1CITY
  383. Join=T9METRO.METROCD,T1CITY.METROCD
  384. SQL=SELECT T9METRO.NAME, T9METRO.METROCD FROM T9METRO LEFT JOIN T1CITY ON T9METRO.METROCD = T1CITY.METROCD
  385. Column1=METRONAME,TEXT
  386. Column2=METROCD,TEXT
  387.  
  388. [qryGET_AIR_CITY_LIST]
  389. Name=T2ARPT,T1CITY
  390. Join=T2ARPT.REFCITY,T1CITY.CITYCD
  391. SQL=SELECT T2ARPT.NAME, T2ARPT.ARPTCD, T1CITY.NAME FROM T2ARPT LEFT JOIN T1CITY ON T2ARPT.REFCITY = T1CITY.CITYCD
  392. Column1=ARPTNAME,TEXT
  393. Column2=ARPTCD,TEXT
  394. Column3=CITYNAME,TEXT
  395.  
  396. [qryGET_CITY_LIST]
  397. Name=T1CITY
  398. SQL=SELECT T1CITY.NAME, T1CITY.CITYCD FROM T1CITY
  399. Column1=CITYNAME,TEXT
  400. Column2=CITYCD,TEXT
  401.  
  402. [qryMAX_TREGUSER_ID]
  403. Name=TREGUSER
  404. SQL=SELECT MAX(ID) FROM TREGUSER
  405. Column1=MAX,long
  406.  
  407. [qryBILLING_TRAV]
  408. Name=TTRAVELE,TCREDITC
  409. Join=TTRAVELE.ID,TCREDITC.TR_ID
  410. SQL=SELECT DISTINCT TTRAVELE.ID, TTRAVELE.TITLE, TTRAVELE.FIRST, TTRAVELE.LAST FROM TTRAVELE, TCREDITC
  411. Column1=ID,long
  412. Column2=TITLE,TEXT
  413. Column3=FIRST,TEXT
  414. Column4=LAST,TEXT
  415.  
  416. [qryAIRPORTCB]
  417. Name=T2ARPT
  418. SQL=SELECT DISTINCT ARPTCD, NAME FROM T2ARPT
  419. Column1=ARPTCD,TEXT
  420. Column2=NAME,TEXT
  421.  
  422. [qryVENDORS]
  423. Name=TMODEMS
  424. SQL=SELECT DISTINCT VENDOR FROM TMODEMS ORDER BY VENDOR
  425. Column1=VENDOR,TEXT
  426.  
  427. [qryMODEMS]
  428. Name=TMODEMS
  429. SQL=SELECT MODEM FROM TMODEMS
  430. Column1=MODEM,TEXT
  431.  
  432. [qryINITIALIZATION]
  433. Name=TMODEMS
  434. SQL=SELECT INITIALIZE FROM TMODEMS
  435. Column1=INITIALIZE,TEXT
  436.  
  437. [qryVAN]
  438. Name=TVAN
  439. SQL=SELECT AREACODE, PHONENUMBR FROM TVAN
  440. Column1=AREACODE,TEXT
  441. Column2=PHONENUMBR,TEXT
  442.  
  443. [qryMileagePlusMembers]
  444. Name=TTRAVELE,TAWARDPG
  445. Join=TTRAVELE.ID,TAWARDPG.TR_ID
  446. SQL=SELECT DISTINCT TTRAVELE.LAST, TTRAVELE.FIRST, TTRAVELE.MIDDLE, TTRAVELE.TITLE, TAWARDPG.MEMBERID FROM TAWARDPG INNER JOIN TTRAVELE ON TAWARDPG.TR_ID = TTRAVELE.ID WHERE TAWARDPG.VENDORTYPE='A' AND TAWARDPG.VENDORCD='UA' ORDER BY TTRAVELE.ID
  447. Column1=LAST,TEXT
  448. Column2=FIRST,TEXT
  449. Column3=MIDDLE,TEXT
  450. Column4=TITLE,TEXT
  451. Column5=MILEPLUSID,TEXT
  452.